Re: questions about disk configurations
От | eric soroos |
---|---|
Тема | Re: questions about disk configurations |
Дата | |
Msg-id | 88699896.1172681174@[4.42.179.151] обсуждение исходный текст |
Ответ на | Re: questions about disk configurations (Josh Berkus <josh@agliodbs.com>) |
Ответы |
Re: questions about disk configurations
Re: questions about disk configurations |
Список | pgsql-performance |
> > Er, no, it's not. In fact, for a 3-disk config, I reccommend: > > Disk 1: OS, swap, system logs > Disk 2: Data + Indexes > Disk 3: Transaction Log What is the accepted way of splitting the data from pg_xlog? I've been testing some configurations for low budget performance, and I haven't been able to make this help vs. one disk.(under osx, ymmv) I rsync'd the pg_xlog directory to another disk, then set up a symlink pointing from the data/pg_xlog to /other/disk/pg_xlog. I then got tps numbers that were 2/3 of the single ide drive speed. The only explanation I can come up with is that somethingis seeking to the symlink, then doing the actual write on the other drive. I'm going to try this under linux using mount points, but I need to shuffle hardware first. any ideas? eric
В списке pgsql-performance по дате отправления: